Public Class OrderStatuss
    Inherits DABase


    Public Function GetLastestOrderStatusList(ByVal customerID As Integer, ByVal supplierID As Integer) As DataSet
        Dim sqlCommand As New SqlClient.SqlCommand

        sqlCommand.CommandText = "[GetLastestOrderStatusListByCustomerId]"
        sqlCommand.CommandType = System.Data.CommandType.StoredProcedure
        sqlCommand.Connection = Me.Connection
        sqlCommand.Transaction = Me.Transaction

        sqlCommand.Parameters.Add("@CUSTOMER_ID_FK", customerID)
        sqlCommand.Parameters.Add("@SUPPLIER_ID_FK", supplierID)

        Dim ds As New DataSet

        Dim da As New SqlDataAdapter(sqlCommand)

        da.Fill(ds)

        Return ds
    End Function

    Public Sub GetLastestOrderStatus(ByVal orderID As Integer, ByRef ds As DataSet)
        Dim sqlCommand As New SqlClient.SqlCommand

        sqlCommand.CommandText = "[GetLastestOrderStatusByOrderId]"
        sqlCommand.CommandType = System.Data.CommandType.StoredProcedure
        sqlCommand.Connection = Me.Connection
        sqlCommand.Transaction = Me.Transaction

        sqlCommand.Parameters.Add("@ORDER_ID_FK", orderID)

        Dim da As New SqlDataAdapter(sqlCommand)

        da.Fill(ds, ds.Tables(0).TableName)
    End Sub

    Protected Overrides Function getDeleteCommand() As System.Data.SqlClient.SqlCommand
        Dim sqlCommand As New SqlClient.SqlCommand

        sqlCommand.CommandText = "[OrderStatusDeleteCommand]"
        sqlCommand.CommandType = System.Data.CommandType.StoredProcedure
        sqlCommand.Connection = Me.Connection
        sqlCommand.Transaction = Me.Transaction

        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_OS_ID_PK", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "OS_ID_PK", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_COST", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "COST", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CREATED_BY", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CREATED_BY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CREATED_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CREATED_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DEPARTURE_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "DEPARTURE_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DOC_SENT", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "DOC_SENT", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DOC_SENT_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "DOC_SENT_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "EST_TIME_ARRIVAL", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PREV_EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PREV_EST_TIME_ARRIVAL", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "EST_TIME_DELIVERY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PREV_EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PREV_EST_TIME_DELIVERY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_INVOICE_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "INVOICE_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_INVOICE_NO", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "INVOICE_NO", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_INVOICE_VALUE", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "INVOICE_VALUE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_LAST_UPDATED", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "LAST_UPDATED", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ORDER_ID_FK", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ORDER_ID_FK", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PAY_RECEIVED", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PAY_RECEIVED", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PAY_RECEIVED_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PAY_RECEIVED_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PERCENT_COMPLETED", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(2, Byte), "PERCENT_COMPLETED", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_UPDATED_BY", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "UPDATED_BY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_VESSEL", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "VESSEL", System.Data.DataRowVersion.Original, Nothing))

        Return sqlCommand
    End Function

    Protected Overrides Function getInsertCommand() As System.Data.SqlClient.SqlCommand
        Dim sqlCommand As New SqlClient.SqlCommand

        sqlCommand.CommandText = "[OrderStatusInsertCommand]"
        sqlCommand.CommandType = System.Data.CommandType.StoredProcedure
        sqlCommand.Connection = Me.Connection
        sqlCommand.Transaction = Me.Transaction

        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ORDER_ID_FK", System.Data.SqlDbType.Int, 4, "ORDER_ID_FK"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LAST_UPDATED", System.Data.SqlDbType.DateTime, 8, "LAST_UPDATED"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PERCENT_COMPLETED", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(2, Byte), "PERCENT_COMPLETED", System.Data.DataRowVersion.Current, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, "EST_TIME_DELIVERY"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PREV_EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, "PREV_EST_TIME_DELIVERY"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DEPARTURE_DATE", System.Data.SqlDbType.DateTime, 8, "DEPARTURE_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@VESSEL", System.Data.SqlDbType.VarChar, 50, "VESSEL"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, "EST_TIME_ARRIVAL"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PREV_EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, "PREV_EST_TIME_ARRIVAL"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DOC_SENT", System.Data.SqlDbType.Bit, 1, "DOC_SENT"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DOC_SENT_DATE", System.Data.SqlDbType.DateTime, 8, "DOC_SENT_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PAY_RECEIVED", System.Data.SqlDbType.Bit, 1, "PAY_RECEIVED"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PAY_RECEIVED_DATE", System.Data.SqlDbType.DateTime, 8, "PAY_RECEIVED_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@INVOICE_NO", System.Data.SqlDbType.VarChar, 20, "INVOICE_NO"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@INVOICE_DATE", System.Data.SqlDbType.DateTime, 8, "INVOICE_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@INVOICE_VALUE", System.Data.SqlDbType.Money, 8, "INVOICE_VALUE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@COST", System.Data.SqlDbType.Money, 8, "COST"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CREATED_BY", System.Data.SqlDbType.Int, 4, "CREATED_BY"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CREATED_DATE", System.Data.SqlDbType.DateTime, 8, "CREATED_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UPDATED_BY", System.Data.SqlDbType.Int, 4, "UPDATED_BY"))

        Return sqlCommand
    End Function

    Protected Overrides Function getSelectCommand(ByVal keys() As Object) As System.Data.SqlClient.SqlCommand
        Dim sqlCommand As New SqlClient.SqlCommand

        sqlCommand.CommandText = "[OrderStatusSelectCommand]"
        sqlCommand.CommandType = System.Data.CommandType.StoredProcedure
        sqlCommand.Connection = Me.Connection
        sqlCommand.Transaction = Me.Transaction

        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
        Dim param As SqlParameter
        param = New SqlClient.SqlParameter("@ORDER_ID_FK", System.Data.SqlDbType.Int, 4, "ORDER_ID_FK")
        param.Value = keys(0)
        sqlCommand.Parameters.Add(param)

        param = New SqlParameter("@WEEK", System.Data.SqlDbType.Int, 4)
        param.Value = keys(1)
        sqlCommand.Parameters.Add(param)
        param = New SqlParameter("@YEAR", System.Data.SqlDbType.Int, 4)
        param.Value = keys(2)
        sqlCommand.Parameters.Add(param)

        Return sqlCommand
    End Function

    Protected Overrides Function getUpdateCommand() As System.Data.SqlClient.SqlCommand
        Dim sqlCommand As New SqlClient.SqlCommand

        sqlCommand.CommandText = "[OrderStatusUpdateCommand]"
        sqlCommand.CommandType = System.Data.CommandType.StoredProcedure
        sqlCommand.Connection = Me.Connection
        sqlCommand.Transaction = Me.Transaction

        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ORDER_ID_FK", System.Data.SqlDbType.Int, 4, "ORDER_ID_FK"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LAST_UPDATED", System.Data.SqlDbType.DateTime, 8, "LAST_UPDATED"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PERCENT_COMPLETED", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(2, Byte), "PERCENT_COMPLETED", System.Data.DataRowVersion.Current, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, "EST_TIME_DELIVERY"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PREV_EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, "PREV_EST_TIME_DELIVERY"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DEPARTURE_DATE", System.Data.SqlDbType.DateTime, 8, "DEPARTURE_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@VESSEL", System.Data.SqlDbType.VarChar, 50, "VESSEL"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, "EST_TIME_ARRIVAL"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PREV_EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, "PREV_EST_TIME_ARRIVAL"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DOC_SENT", System.Data.SqlDbType.Bit, 1, "DOC_SENT"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DOC_SENT_DATE", System.Data.SqlDbType.DateTime, 8, "DOC_SENT_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PAY_RECEIVED", System.Data.SqlDbType.Bit, 1, "PAY_RECEIVED"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PAY_RECEIVED_DATE", System.Data.SqlDbType.DateTime, 8, "PAY_RECEIVED_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@INVOICE_NO", System.Data.SqlDbType.VarChar, 20, "INVOICE_NO"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@INVOICE_DATE", System.Data.SqlDbType.DateTime, 8, "INVOICE_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@INVOICE_VALUE", System.Data.SqlDbType.Money, 8, "INVOICE_VALUE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@COST", System.Data.SqlDbType.Money, 8, "COST"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CREATED_BY", System.Data.SqlDbType.Int, 4, "CREATED_BY"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CREATED_DATE", System.Data.SqlDbType.DateTime, 8, "CREATED_DATE"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UPDATED_BY", System.Data.SqlDbType.Int, 4, "UPDATED_BY"))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_OS_ID_PK", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "OS_ID_PK", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_COST", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "COST", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CREATED_BY", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CREATED_BY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CREATED_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CREATED_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DEPARTURE_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "DEPARTURE_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DOC_SENT", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "DOC_SENT", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DOC_SENT_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "DOC_SENT_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "EST_TIME_ARRIVAL", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PREV_EST_TIME_ARRIVAL", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PREV_EST_TIME_ARRIVAL", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "EST_TIME_DELIVERY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PREV_EST_TIME_DELIVERY", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PREV_EST_TIME_DELIVERY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_INVOICE_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "INVOICE_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_INVOICE_NO", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "INVOICE_NO", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_INVOICE_VALUE", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "INVOICE_VALUE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_LAST_UPDATED", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "LAST_UPDATED", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ORDER_ID_FK", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ORDER_ID_FK", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PAY_RECEIVED", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PAY_RECEIVED", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PAY_RECEIVED_DATE", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PAY_RECEIVED_DATE", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PERCENT_COMPLETED", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(2, Byte), "PERCENT_COMPLETED", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_UPDATED_BY", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "UPDATED_BY", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_VESSEL", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "VESSEL", System.Data.DataRowVersion.Original, Nothing))
        sqlCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@OS_ID_PK", System.Data.SqlDbType.Int, 4, "OS_ID_PK"))

        Return sqlCommand
    End Function
End Class
